<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_order_goods`;");
E_C("CREATE TABLE `ecs_order_goods` (
  `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_name` varchar(120) NOT NULL DEFAULT '',
  `goods_sn` varchar(60) NOT NULL DEFAULT '',
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_number` smallint(5) unsigned NOT NULL DEFAULT '1',
  `market_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `goods_attr` text NOT NULL,
  `send_number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `is_real` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `extension_code` varchar(30) NOT NULL DEFAULT '',
  `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `is_gift` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_attr_id` varchar(255) NOT NULL DEFAULT '',
  `comment_state` tinyint(1) NOT NULL DEFAULT '0',
  `shaidan_state` tinyint(1) NOT NULL DEFAULT '0',
  `package_attr_id` varchar(100) NOT NULL,
  `send_store_number` smallint(5) unsigned NOT NULL,
  `send_store_id` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`rec_id`),
  KEY `order_id` (`order_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=97 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_order_goods` values('1','1','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','1','1','','0','0','403','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('2','2','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','1','1','','0','0','290','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('3','3','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','1','1','','0','0','290','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('4','4','52','美的(Midea) KFR-51LW/BP2DN1Y-YA200(A2)（摩卡棕） 2匹 立柜式冷暖变频空调','ECS000052','102','1','3598.79','2999.00','颜色:灰色 \n','0','1','','0','0','151','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('5','5','57','美的(Midea) KFR-51LW/DY-IF(R3) 2匹 立柜式冷暖定速空调 ','ECS000057','107','1','4185.59','3488.00','颜色:白色 \n','0','1','','0','0','161','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('6','6','63','[戈尔本] 锐·风尚系列全粒面牛皮休闲斜挎包','ECS000063','357','1','4107.59','333.00','颜色:黄色 \n','1','1','','0','0','165','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('7','7','95','[希夏邦马]城市生活系列多用包 ','ECS000095','336','1','1054.80','788.00','颜色:蓝色 \n','0','1','','0','0','262','0','0','','1','8');");
E_D("replace into `ecs_order_goods` values('8','8','45','[ARMANI JEANS]阿玛尼V5296A3-7H','ECS000045','326','1','386.40','322.00','颜色:蓝色 \n','1','1','','0','0','137','0','0','','1','9');");
E_D("replace into `ecs_order_goods` values('9','9','83','[戈尔本]复古回潮系列沙色油蜡头层牛皮手提可斜挎包','ECS000083','339','1','279.59','211.00','颜色:黄色 \n','1','1','','0','0','223','0','0','','1','9');");
E_D("replace into `ecs_order_goods` values('10','10','95','[希夏邦马]城市生活系列多用包 ','ECS000095','336','1','1054.80','788.00','颜色:蓝色 \n','0','1','','0','0','262','0','0','','1','9');");
E_D("replace into `ecs_order_goods` values('11','11','49','[MCM]经典休闲背包MMK2AVE17 ','ECS000049','321','1','146.40','89.00','颜色:蓝色 \n','0','1','','0','0','147','0','0','','1','9');");
E_D("replace into `ecs_order_goods` values('12','12','89','[martin ma]SPORTS系列韩范旅行包','ECS000089','344','1','784.80','433.00','颜色:白色 \n','0','1','','0','0','242','0','0','','1','9');");
E_D("replace into `ecs_order_goods` values('13','13','95','[希夏邦马]城市生活系列多用包 ','ECS000095','336','1','1054.80','0.00','颜色:蓝色 \r\n','0','1','','0','0','262','0','0','','1','9');");
E_D("replace into `ecs_order_goods` values('14','15','83','[戈尔本]复古回潮系列沙色油蜡头层牛皮手提可斜挎包','ECS000083','339','1','279.59','211.00','颜色:黄色 \n','0','1','','0','0','223','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('15','15','63','[戈尔本] 锐·风尚系列全粒面牛皮休闲斜挎包','ECS000063','357','1','4107.59','333.00','颜色:黄色 \n','0','1','','0','0','165','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('16','16','98','[浪美]爱豆系列手提双肩背包 ','ECS000098','385','1','547.19','321.00','颜色:蓝色 \n','0','1','','0','0','269','0','0','','1','8');");
E_D("replace into `ecs_order_goods` values('17','17','95','[希夏邦马]城市生活系列多用包 ','ECS000095','336','1','1054.80','788.00','颜色:蓝色 \n','0','1','','0','0','262','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('18','17','92','[戈尔本]耀世典范系列臻品牛皮手包','ECS000092','343','1','920.40','555.00','颜色:黑色 \n','0','1','','0','0','252','0','0','','1','9');");
E_D("replace into `ecs_order_goods` values('19','18','92','[戈尔本]耀世典范系列臻品牛皮手包','ECS000092','343','1','920.40','555.00','颜色:黑色 \n','0','1','','0','0','252','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('20','19','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','0','1','','0','0','290','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('21','20','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','0','1','','0','0','290','0','0','','1','11');");
E_D("replace into `ecs_order_goods` values('22','20','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','388','1','106.80','67.00','颜色:黄色 \n','0','1','','0','0','291','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('23','21','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','0','1','','0','0','290','0','0','','1','11');");
E_D("replace into `ecs_order_goods` values('24','22','78','[希夏邦马]Gent系列手提双肩包 ','ECS000078','355','1','679.19','455.00','颜色:蓝色 \n','1','1','','0','0','205','0','0','','1','17');");
E_D("replace into `ecs_order_goods` values('25','22','63','[戈尔本] 锐·风尚系列全粒面牛皮休闲斜挎包','ECS000063','357','1','4107.59','333.00','颜色:黄色 \n','1','1','','0','0','165','0','0','','1','17');");
E_D("replace into `ecs_order_goods` values('26','23','80','[戈尔本]致雅格调系列头层牛皮手提可斜挎公文包','ECS000080','349','1','1410.00','988.00','颜色:黑色 \n','1','1','','0','0','215','0','0','','1','16');");
E_D("replace into `ecs_order_goods` values('27','24','83','[戈尔本]复古回潮系列沙色油蜡头层牛皮手提可斜挎包','ECS000083','339','1','279.59','211.00','颜色:黄色 \n','1','1','','0','0','223','0','0','','1','15');");
E_D("replace into `ecs_order_goods` values('28','25','178','Gucci','ECS000178','0','2','1200.00','777.00','','2','1','','0','0','','0','0','','2','21');");
E_D("replace into `ecs_order_goods` values('29','26','180','AMH男装冬装新款韩版纯色修身加厚连帽棉衣OD2252','ECS000180','0','1','468.00','390.00','','0','1','','0','0','','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('30','27','147','68ecshop店铺商品测试','ECS000147','402','1','838.80','699.00','颜色:蓝色 \n','0','1','','0','0','438','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('31','28','180','AMH男装冬装新款韩版纯色修身加厚连帽棉衣OD2252','ECS000180','0','1','468.00','390.00','','0','1','','0','0','','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('32','29','177','女装灰色韩版时尚拼接双排扣毛呢外套GW3175【韩都衣舍 2014冬装新款】','ECS000177','0','1','660.00','550.00','','0','1','','0','0','','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('33','30','177','女装灰色韩版时尚拼接双排扣毛呢外套GW3175【韩都衣舍 2014冬装新款】','ECS000177','0','1','660.00','550.00','','0','1','','0','0','','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('34','31','178','Gucci','ECS000178','0','1','1200.00','777.00','','1','1','','0','0','','0','0','','1','21');");
E_D("replace into `ecs_order_goods` values('35','32','181','Aideuw','00001','0','1','666.00','0.00','','0','1','','0','0','','0','0','','1','21');");
E_D("replace into `ecs_order_goods` values('36','33','180','AMH男装冬装新款韩版纯色修身加厚连帽棉衣OD2252','ECS000180','0','1','468.00','390.00','','1','1','','0','0','','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('37','34','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','0','1','','0','0','403','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('39','36','98','[浪美]爱豆系列手提双肩背包 ','ECS000098','384','1','547.19','321.00','颜色:白色 \n','0','1','','0','0','270','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('38','35','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','0','1','','0','0','403','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('40','37','136','飞利浦吸尘器 家用2000W无尘袋吸尘器FC8760 可水洗大功率','ECS000136','0','2','1078.80','899.00','','2','1','','0','0','','0','0','','2','3');");
E_D("replace into `ecs_order_goods` values('41','38','78','[希夏邦马]Gent系列手提双肩包 ','ECS000078','354','2','679.19','455.00','颜色:水绿色 \n','2','1','','0','0','206','0','0','','2','4');");
E_D("replace into `ecs_order_goods` values('42','38','21','Party Star伏特加果冻酒 酒精果冻鸡尾酒调酒 12颗礼盒装6个口味','ECS000021','0','1','87.60','0.00','','1','1','','0','17','','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('43','38','2','水清梦兰 2014秋季女装新款修身纯色棉麻防嗮宽松长袖衬衫女','ECS000002','0','1','270.00','0.00','','1','1','','0','14','','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('44','39','136','飞利浦吸尘器 家用2000W无尘袋吸尘器FC8760 可水洗大功率','ECS000136','0','1','1078.80','899.00','','0','1','','0','0','','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('45','40','56','Milky Moon Cake','ECS000056','0','77','153.60','128.00','','77','1','','0','0','','0','0','','77','3');");
E_D("replace into `ecs_order_goods` values('46','41','128',' 西门子嵌入式咖啡机TK76K573CN ','ECS000128','0','1','8132.40','6777.00','','1','1','','0','0','','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('47','42','106','[希夏邦马]俏皮迷彩风系列双肩包','ECS000106','392','1','543.60','321.00','颜色:水绿色 \n','0','1','','0','0','305','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('49','44','49','[MCM]经典休闲背包MMK2AVE17 ','ECS000049','320','1','146.40','89.00','颜色:黑色 \n','0','1','','0','0','148','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('48','43','106','[希夏邦马]俏皮迷彩风系列双肩包','ECS000106','391','1','543.60','321.00','颜色:蓝色 \n','0','1','','0','0','306','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('50','45','49','[MCM]经典休闲背包MMK2AVE17 ','ECS000049','321','1','146.40','89.00','颜色:蓝色 \n','0','1','','0','0','147','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('51','46','49','[MCM]经典休闲背包MMK2AVE17 ','ECS000049','321','1','146.40','89.00','颜色:蓝色 \n','0','1','','0','0','147','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('52','47','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','1','1','','0','0','403','0','0','','1','3');");
E_D("replace into `ecs_order_goods` values('53','48','178','Gucci','ECS000178','0','1','1200.00','777.00','','0','1','','0','0','','0','0','','1','21');");
E_D("replace into `ecs_order_goods` values('54','49','178','Gucci','ECS000178','0','315','1200.00','777.00','','315','1','','0','0','','0','0','','315','21');");
E_D("replace into `ecs_order_goods` values('55','50','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','1','1','','0','0','290','0','0','','1','11');");
E_D("replace into `ecs_order_goods` values('56','51','178','Gucci','ECS000178','0','33','1200.00','777.00','','33','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('57','52','179','古驰女士手拿包','ECS000179','0','1','7200.00','6000.00','','1','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('58','53','178','Gucci','ECS000178','0','10098','1200.00','777.00','','10098','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('59','54','136','飞利浦吸尘器 家用2000W无尘袋吸尘器FC8760 可水洗大功率','ECS000136','0','1','1078.80','899.00','','1','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('60','55','50','台湾统一满汉大餐方便面进口珍味牛肉面速食泡面浓郁汤料大块牛肉','ECS000050','0','8','18.24','15.20','','0','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('61','56','44','【一山半海】PEKOE精选 叶怡兰推荐 台湾文山包种茶 冷泡送女友','ECS000044','0','2','90.00','75.00','','0','1','','0','0','','0','0','','2','3');");
E_D("replace into `ecs_order_goods` values('62','57','178','Gucci','ECS000178','0','2','1200.00','777.00','','0','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('63','58','179','古驰女士手拿包','ECS000179','0','1','1200.00','1000.00','','0','1','','0','0','','0','0','','1','22');");
E_D("replace into `ecs_order_goods` values('64','59','179','古驰女士手拿包','ECS000179','0','1','1200.00','1000.00','','1','1','','0','0','','0','0','','1','22');");
E_D("replace into `ecs_order_goods` values('65','60','49','[MCM]经典休闲背包MMK2AVE17 ','ECS000049','321','1','146.40','89.00','颜色:蓝色 \n','0','1','','0','0','147','0','0','','1','4');");
E_D("replace into `ecs_order_goods` values('66','61','49','[MCM]经典休闲背包MMK2AVE17 ','ECS000049','321','1','146.40','89.00','颜色:蓝色 \n','0','1','','0','0','147','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('67','62','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','1','1','','0','0','403','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('68','63','98','[浪美]爱豆系列手提双肩背包 ','ECS000098','384','1','547.19','321.00','颜色:白色 \n','1','1','','0','0','270','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('69','64','100','[DELSEY]四轮纤巧登机拉杆箱20寸','ECS000100','387','3','414.00','322.00','颜色:粉色 \n','3','1','','0','0','282','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('70','65','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','1','1','','0','0','290','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('71','66','80','[戈尔本]致雅格调系列头层牛皮手提可斜挎公文包','ECS000080','349','1','1410.00','988.00','颜色:黑色 \n','1','1','','0','0','215','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('72','66','89','[martin ma]SPORTS系列韩范旅行包','ECS000089','344','1','784.80','433.00','颜色:白色 \n','1','1','','0','0','242','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('73','66','86','[德琳] 遂行系列手提/斜挎旅行包 ','ECS000086','346','1','1051.20','675.00','颜色:黄色 \n','1','1','','0','0','233','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('74','66','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','380','1','414.00','299.00','颜色:粉色 \n','1','1','','0','0','404','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('75','67','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','1','1','','0','0','403','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('76','69','181','Aideuw','00001','0','1','1065.00','888.00','','1','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('77','70','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','0','1','','0','0','403','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('78','71','100','[DELSEY]四轮纤巧登机拉杆箱20寸','ECS000100','387','1','414.00','322.00','颜色:粉色 \n','1','1','','0','0','282','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('79','72','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','0','1','414.00','299.00','','0','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('80','73','100','[DELSEY]四轮纤巧登机拉杆箱20寸','ECS000100','386','1','414.00','322.00','颜色:黑色 \n','0','1','','0','0','283','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('81','74','178','Gucci','ECS000178','0','1','1200.00','777.00','','1','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('82','75','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','1','1','','0','0','403','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('83','75','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','ECS000102','389','1','106.80','67.00','颜色:粉色 \n','1','1','','0','0','290','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('84','76','98','[浪美]爱豆系列手提双肩背包 ','ECS000098','384','1','547.19','321.00','颜色:白色 \n','1','1','','0','0','270','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('85','77','180','AMH男装冬装新款韩版纯色修身加厚连帽棉衣OD2252','ECS000180','0','2','468.00','390.00','','2','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('86','78','111','[希夏邦马]hello BUGS系列单肩包','ECS000111','379','1','414.00','299.00','颜色:蓝色 \n','1','1','','0','0','403','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('87','79','182','正品男包牛皮商务竖款 男士包包手提包','ECS000182','0','1','1197.60','998.00','','1','1','','0','0','','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('88','80','183','男士手提包竖款2014新款男士包包潮流','ECS000183','521','1','1165.60','988.00','颜色:白色[100] \n','1','1','','0','0','539','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('89','81','183','男士手提包竖款2014新款男士包包潮流','ECS000183','521','1','1165.60','988.00','颜色:白色[100] \n','1','1','','0','0','539','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('90','82','183','男士手提包竖款2014新款男士包包潮流','ECS000183','521','1','1165.60','988.00','颜色:白色[100] \n','1','1','','0','0','539','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('91','83','183','男士手提包竖款2014新款男士包包潮流','ECS000183','521','2','1165.60','988.00','颜色:白色[100] \n','2','1','','0','0','539','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('92','84','183','男士手提包竖款2014新款男士包包潮流','ECS000183','521','1','1165.60','988.00','颜色:白色[100] \n','1','1','','0','0','539','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('93','85','121','亿觅emie米兔移动电源小米卡通可爱迷你充电宝正品手机通用 ','ECS000121','284','1','106.80','89.00','颜色:白色 \n','0','1','','0','0','367','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('94','86','121','亿觅emie米兔移动电源小米卡通可爱迷你充电宝正品手机通用 ','ECS000121','284','1','106.80','89.00','颜色:白色 \n','0','1','','0','0','367','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('95','87','121','亿觅emie米兔移动电源小米卡通可爱迷你充电宝正品手机通用 ','ECS000121','284','1','106.80','89.00','颜色:白色 \n','0','1','','0','0','367','0','0','','0','0');");
E_D("replace into `ecs_order_goods` values('96','88','178','Gucci','ECS000178','0','1','1200.00','777.00','','0','1','','0','0','','0','0','','1','4');");

require("../../inc/footer.php");
?>